-- @owner: lihongji
-- @date: 2022/6/15
-- @testpoint: 移植

--step1: 建表     expect: 建表成功
drop table if exists t_ustore_corr_0001_01;
create table t_ustore_corr_0001_01 (empno number(4) not null, ename varchar2(10), job varchar2(9), sal number(7, 2), sal_1 number(7,2), deptno number(2)) with (storage_type=ustore);
drop table if exists t_ustore_corr_0001_02;
create table t_ustore_corr_0001_02 (empno number(4) not null, ename varchar2(10), job varchar2(9), sal number(7, 2), sal_1 number(7,2), deptno number(2)) with (storage_type=ustore);
drop table if exists t_ustore_corr_0001_03;
create table t_ustore_corr_0001_03 (empno number(4) not null, ename varchar2(10), job varchar2(9), sal number(7, 2), sal_1 number, deptno number(2)) with (storage_type=ustore);
drop table if exists t_ustore_corr_0001_04;
create table t_ustore_corr_0001_04 (empno number(4) not null, ename varchar2(10), job varchar2(9), sal number(10, 3), sal_1 number, deptno number(2)) with (storage_type=ustore);
drop table if exists t_ustore_corr_0001_05;
create table  t_ustore_corr_0001_05 (empno number(4) not null, ename varchar2(10), job varchar2(9), sal number(7, 2), sal_1 number(7, 2), deptno number(2)) with (storage_type=ustore);
drop table if exists t_ustore_corr_0001_06;
create table t_ustore_corr_0001_06 (empno number(4) not null, ename varchar2(10), job varchar2(9), sal varchar2(10), sal_1 varchar2(10), deptno number(2)) with (storage_type=ustore);
drop table if exists t_ustore_corr_0001_07;
create table t_ustore_corr_0001_07(id int not null ,c_int int ,c_integer integer not null ) with (storage_type=ustore);
drop table if exists t_ustore_corr_0001_08;
create table  t_ustore_corr_0001_08(
     col_1 integer,
     col_2 number(19,0),
     col_3 number(10,6)
) with (storage_type=ustore);

--step2:插入数据     expect: 插入成功
insert into t_ustore_corr_0001_01 values (1, 'smith', 'clerk',     800,  600,   20);
insert into t_ustore_corr_0001_01 values (2, 'allen', 'salesman', 1600, 1300,   30);
insert into t_ustore_corr_0001_01 values (3, 'ward',  'salesman', 1250, 1100,   30);
insert into t_ustore_corr_0001_01 values (4, 'jones', 'manager',  2975, 2450,   20);
insert into t_ustore_corr_0001_01 values (5, 'martin','salesman', 1250, 1500,   30);
insert into t_ustore_corr_0001_01 values (6, 'blake', 'manager',  2850, 3000,   30);
insert into t_ustore_corr_0001_01 values (7, 'clark', 'manager',  2850, 2500,   10);
insert into t_ustore_corr_0001_01 values (8, 'scott', 'analyst',  3000, 2000,   20);
insert into t_ustore_corr_0001_01 values (9, 'king',  'president',3000, 3500,   10);
insert into t_ustore_corr_0001_01 values (10,'turner','salesman', 1500,  600,   30);
insert into t_ustore_corr_0001_01 values (11,'adams', 'clerk',    1500, 2000,   20);
insert into t_ustore_corr_0001_01 values (12,'lily',  'analyst',  2000, null,   20);
insert into t_ustore_corr_0001_01 values (13,'bob',  'salesman',    '', 2000,   20);
insert into t_ustore_corr_0001_01(empno, ename, job, deptno) values (14, 'amy', 'manager', 30);
insert into t_ustore_corr_0001_02 values (1, 'smith', 'clerk',   800,  600,   20);
insert into t_ustore_corr_0001_03 values (1, 'smith1', 'clerk',  8000,  null,  30);
insert into t_ustore_corr_0001_03 values (2, 'smith2', 'clerk',  null,  6000,  20);
insert into t_ustore_corr_0001_03 values (3, 'smith3', 'clerk',  null,  null,  10);
insert into t_ustore_corr_0001_04 values (20, 'blake1', 'manager',  1,  1,  30);
insert into t_ustore_corr_0001_04 values (21, 'blake1', 'manager',  999999,  999999,  30);
insert into t_ustore_corr_0001_04 values (22, 'blake1', 'manager', 1125000, 1125000, 30);
insert into t_ustore_corr_0001_05 values (20, 'blake1', 'manager',  1000,   800,  30);
insert into t_ustore_corr_0001_05 values (21, 'blake2', 'manager',  null,  null,  30);
insert into t_ustore_corr_0001_05 values (22, 'smith1',  'clerk',   8000,  6000,  20);
insert into t_ustore_corr_0001_05 values (23, 'smith2',  'clerk',   5000,  3250,  30);
insert into t_ustore_corr_0001_05 values (24, 'smith3',  'clerk',   3500,  3250,  10);
insert into t_ustore_corr_0001_06 values (20, 'blake1', 'manager',  '1000',   '800',  30);
insert into t_ustore_corr_0001_06 values (21, 'blake2', 'manager',  '9999',  '1000',  30);
insert into t_ustore_corr_0001_06(empno, ename, job, sal, deptno) values (22, 'blake3', 'manager', '4000', 30);
insert into t_ustore_corr_0001_07 values(1,11,111);
insert into t_ustore_corr_0001_07 values(2,22,222);
insert into t_ustore_corr_0001_07 values(3,33,333);
insert into t_ustore_corr_0001_07 values(1,12,333);

--step3:创建序列     expect: 创建成功
drop sequence if exists pop_samp_variance_seq_corr;
create sequence pop_samp_variance_seq_corr increment by 1 start with 10;

--step4:数据创造   expect：成功
begin
	for i in 1..50 loop
      insert into t_ustore_corr_0001_08 values(
	  i,	  
      pop_samp_variance_seq_corr.nextval,
	  i+445.255
	  );

    end loop;
end;
/
